| FaEstimate |
| Logical Entity Name | FaEstimate |
| Default Table Name | FaEstimate |
| Physical Only | NO |
| Definition | |
| Note |
| FaEstimate Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
FaEstimateID |
int | NO | ||
SyStudentID |
int | NO | ||
FaPackMethodID |
int | YES | ||
AdProgramVersionID |
int | YES | ||
AdGradeLevelID |
int | YES | ||
AdAttStatID |
int | YES | ||
| PellAmount1 | money | NO | ||
| PellAmount2 | money | YES | ||
| EstEFCAwardYear1 | money | NO | ||
| PrintDate | datetime | YES | ||
| StartDate | datetime | YES | ||
| AwardYear1 | char(7) | NO | ||
| Model | char(1) | YES | ||
| EstimatedCOA | money | NO | ||
| StudentMarried | bit | NO | ||
| StudentExemptions | int | NO | ||
| StudentIncome | money | NO | ||
| StudentIncomeTax | money | NO | ||
| StudentNumFamily | smallint | NO | ||
| StudentNumCollege | smallint | NO | ||
| StudentLegState | char(2) | NO | ||
| ParentMarried | bit | NO | ||
| ParentExemptions | int | NO | ||
| ParentIncome | money | NO | ||
| ParentIncomeTax | money | NO | ||
| ParentNumFamily | smallint | NO | ||
| ParentNumCollege | smallint | NO | ||
| ParentLegState | char(2) | YES | ||
UserID |
int | NO | ||
| DateAdded | datetime | NO | ||
| DateLstMod | datetime | NO | ||
| Ts | timestamp | NO | ||
| FaBudgetID | int | YES | ||
| FirstTimeBorrower | bit | NO | ||
| AYSeq | int | NO | ||
| HousingStatusCode | char(1) | YES | ||
| HPPALevel | char(1) | NO | ||
| StartDateCode | char(16) | YES |
| FaEstimate Primary and Unique Keys |
| Key Name | Key Type | Keys |
| FaEstimate_FaEstimateID_U_C_IDX | PrimaryKey | FaEstimateID |
| FaEstimate Foreign Keys |
| Parent Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication |
| AdAttStat | Non-Identifying | Zero or One to Zero or More | FK_FaEstimate_AdAttStatID_AdAttStat_AdAttStatID | AdAttStatID | NO | YES | ||
| AdGradeLevel | Non-Identifying | Zero or One to Zero or More | FK_FaEstimate_AdGradeLevelID_AdGradeLevel_AdGradeLevelID | AdGradeLevelID | NO | YES | ||
| AdProgramVersion | Non-Identifying | Zero or One to Zero or More | FK_FaEstimate_AdProgramVersionID_AdProgramVersion_AdProgramVersionID | AdProgramVersionID | NO | YES | ||
| FaPackMeth | Non-Identifying | Zero or One to Zero or More | FK_FaEstimate_FaPackMethodID_FaPackMeth_FaPackMethID | FaPackMethodID | NO | YES | ||
| syStudent | Non-Identifying | One To Zero or More | FK_FaEstimate_SyStudentID_syStudent_SyStudentID | SyStudentID | NO | YES | ||
| SyStaff | Non-Identifying | One To Zero or More | FK_FaEstimate_UserID_SyStaff_SyStaffID | UserID | NO | YES |
| Child Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication |
| FaEstimateAward | Non-Identifying | One To Zero or More | FK_FaEstimateAward_FaEstimateID_FaEstimate_FaEstimateID | NO | YES | |||
| FaEstimateAY | Non-Identifying | One To Zero or More | FK_faEstimateAY_FaEstimateID_FaEstimate_FaEstimateID | NO | YES |
| FaEstimate Check Constraints |
| Check Constraint Name | CheckConstraint |